package com.hjq.mapper;

import com.hjq.pojo.OperateLog;
import com.hjq.pojo.OperateLogResult;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Service;

import java.util.List;

@Mapper
public interface OperateLogMapper {

    //插入日志数据
    @Insert("insert into operate_log (operate_emp_id, operate_time, class_name, method_name, method_params, return_value, cost_time) " +
            "values (#{operateEmpId}, #{operateTime}, #{className}, #{methodName}, #{methodParams}, #{returnValue}, #{costTime});")
    public void insert(OperateLog log);
    @Select("select operate_log.id id, operate_emp_id, operate_time, class_name, method_name, method_params, return_value, cost_time,emp.name operateEmpName" +
            " from operate_log,emp where operate_emp_id=emp.id")
    List<OperateLogResult> findByPage(Integer page, Integer pageSize);
}
